SELECT first_name, last_name, COUNT(DISTINCT place_id) AS places, SUM(DAY(end_date - start_date)) AS days
	FROM PERSON
		JOIN PERSON_GROUP ON (PERSON.id = PERSON_GROUP.person_id)
		JOIN [GROUP] ON ([GROUP].id = PERSON_GROUP.group_id) 
		JOIN PLACE_TIME ON (PLACE_TIME.group_id = [GROUP].id)
	WHERE (YEAR(getdate()) - YEAR([GROUP].global_start) = 1) OR (YEAR(getdate()) - YEAR([GROUP].global_end) = 1)
	GROUP BY first_name, last_name
	ORDER BY 4 DESC
				